<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateCarInfoTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //
	Schema::create('carinfo', function(Blueprint $table)
        {
            $table->increments('id');
            $table->integer('uid')->comment("用户id");
            $table->string('hpzl',2)->comment('号牌种类');
            $table->string('sfjc',5)->comment('省份简称');
            $table->string('dm',1)->comment("代码");
            $table->string('hphm',5)->comment('号牌号码');
            $table->string('clsbdh',6)->comment('车辆识别代号后六位');
            $table->string('sfzmhm',18)->comment('驾驶证号码');
            $table->string('dabh',4)->comment('档案编号后4位');
            $table->timestamps();  //在数据表中会多两个字段 更改和添加的字段  类型是datetime   可以在这下面添加其他的数据类型
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}
